﻿<!DOCTYPE html>
<html lang="en">
<head>
    <title id="Description">TreeGrid with Right to Left Layout.</title>
    <meta name="description" content="This sample demonstrates how we can bind jQWidgets TreeGrid widget to JSON Data by using jQWidgets DataAdapter plugin.">
    <link rel="stylesheet" href="../../jqwidgets/styles/jqx.base.css" type="text/css" />
    <script type="text/javascript" src="../../scripts/jquery-1.11.1.min.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxcore.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxdata.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxbuttons.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxscrollbar.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxdatatable.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxtreegrid.js"></script>
    <script type="text/javascript" src="../../scripts/demos.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {          
            var employees = [{"EmployeeID": 1,"FirstName": "Nancy","LastName": "Davolio","ReportsTo": 2,"Country": "USA","Title": "Sales Representative","HireDate": "1992-05-01 00:00:00","BirthDate": "1948-12-08 00:00:00","City": "Seattle","Address": "507 - 20th Ave. E.Apt. 2A"}, {"EmployeeID": 2,"FirstName": "Andrew","LastName": "Fuller","ReportsTo": null,"Country": "USA","Title": "Vice President, Sales","HireDate": "1992-08-14 00:00:00","BirthDate": "1952-02-19 00:00:00","City": "Tacoma","Address": "908 W. Capital Way"}, {"EmployeeID": 3,"FirstName": "Janet","LastName": "Leverling","ReportsTo": 2,"Country": "USA","Title": "Sales Representative","HireDate": "1992-04-01 00:00:00","BirthDate": "1963-08-30 00:00:00","City": "Kirkland","Address": "722 Moss Bay Blvd."}, {"EmployeeID": 4,"FirstName": "Margaret","LastName": "Peacock","ReportsTo": 2,"Country": "USA","Title": "Sales Representative","HireDate": "1993-05-03 00:00:00","BirthDate": "1937-09-19 00:00:00","City": "Redmond","Address": "4110 Old Redmond Rd."}, {"EmployeeID": 5,"FirstName": "Steven","LastName": "Buchanan","ReportsTo": 2,"Country": "UK","Title": "Sales Manager","HireDate": "1993-10-17 00:00:00","BirthDate": "1955-03-04 00:00:00","City": "London","Address": "14 Garrett Hill"}, {"EmployeeID": 6,"FirstName": "Michael","LastName": "Suyama","ReportsTo": 5,"Country": "UK","Title": "Sales Representative","HireDate": "1993-10-17 00:00:00","BirthDate": "1963-07-02 00:00:00","City": "London","Address": "Coventry House Miner Rd."}, {"EmployeeID": 7,"FirstName": "Robert","LastName": "King","ReportsTo": 5,"Country": "UK","Title": "Sales Representative","HireDate": "1994-01-02 00:00:00","BirthDate": "1960-05-29 00:00:00","City": "London","Address": "Edgeham Hollow Winchester Way"}, {"EmployeeID": 8,"FirstName": "Laura","LastName": "Callahan","ReportsTo": 2,"Country": "USA","Title": "Inside Sales Coordinator","HireDate": "1994-03-05 00:00:00","BirthDate": "1958-01-09 00:00:00","City": "Seattle","Address": "4726 - 11th Ave. N.E."}, {"EmployeeID": 9,"FirstName": "Anne","LastName": "Dodsworth","ReportsTo": 5,"Country": "UK","Title": "Sales Representative","HireDate": "1994-11-15 00:00:00","BirthDate": "1966-01-27 00:00:00","City": "London","Address": "7 Houndstooth Rd."}];

            //// prepare the data
            var source =
            {
                dataType: "json",
                dataFields: [
                    { name: 'EmployeeID', type: 'number' },
                    { name: 'ReportsTo', type: 'number' },
                    { name: 'FirstName', type: 'string' },
                    { name: 'LastName', type: 'string' },
                    { name: 'Country', type: 'string' },
                    { name: 'City', type: 'string' },
                    { name: 'Address', type: 'string' },
                    { name: 'Title', type: 'string' },
                    { name: 'HireDate', type: 'date' },
                    { name: 'BirthDate', type: 'date' }
                ],
                hierarchy:
                {
                    keyDataField: { name: 'EmployeeID' },
                    parentDataField: { name: 'ReportsTo' }
                },
                id: 'EmployeeID',
                localData: employees
            };
            var dataAdapter = new $.jqx.dataAdapter(source);
            // create Tree Grid
            $("#treeGrid").jqxTreeGrid(
            {
                width: 850,
                source: dataAdapter,
                rtl: true,
                ready: function()
                {
                    $("#treeGrid").jqxTreeGrid('expandRow', '2');
                },
                columns: [
                  { text: 'FirstName', columnGroup: 'Name', align: 'right', cellsAlign: 'right', dataField: 'FirstName', width: 200 },
                  { text: 'LastName', columnGroup: 'Name', align: 'right', cellsAlign: 'right', dataField: 'LastName', width: 200 },
                  { text: 'Title', dataField: 'Title', align: 'right', cellsAlign: 'right', width: 160 },
                  { text: 'Birth Date', dataField: 'BirthDate', align: 'right', cellsAlign: 'right', cellsFormat: 'd', width: 120 },
                  { text: 'Hire Date', dataField: 'HireDate', align: 'right', cellsAlign: 'right', cellsFormat: 'd', width: 120 },
                  { text: 'Address', dataField: 'Address', align: 'right', cellsAlign: 'right', width: 250 },
                  { text: 'City', dataField: 'City', align: 'right', cellsAlign: 'right', width: 120 },
                  { text: 'Country', dataField: 'Country', align: 'right', cellsAlign: 'right', width: 200 }
                ]
            });
        });
    </script>
</head>
<body class='default'>
    <div id="treeGrid">
    </div>
</body>
</html>
